ALTER TABLE [dbo].[donorawardmodification]
DROP COLUMN [previousvalue],[newvalue]
GO

ALTER TABLE [dbo].[donorawardmodification]
ADD [modifiedfrom] varchar(255) NOT NULL ,
[modifiedto] varchar(255) NOT NULL ,
[modifieddate] datetime NOT NULL ,
[modifiedby] int NOT NULL 
GO

ALTER TABLE [dbo].[donorawardmodification] ALTER COLUMN [modificationtypeid] int NOT NULL 
GO

ALTER TABLE [dbo].[donorawardmodification] ADD CONSTRAINT [FK__donorawar_modified_by] FOREIGN KEY ([modifiedby]) REFERENCES [dbo].[userinfo] ([id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE1','Start Date Changed');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE2','End Date Changed');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE3','Direct Funds Reduced');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE4','Direct Funds Increased');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE5','Indirect Funds Reduced');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE6','Indirect Funds Increased');
INSERT INTO modificationtype (modificationtypecode,modificationdesc)
VALUES ('MTYPE_CODE7','Status Changed');